Data Quality Report: station

Dataset statistics

Number of variables	16
Number of observations	108035
Missing cells	422673
Missing cells (%)	24.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	30.1 MiB
Average record size in memory	291.8 B

Variable types

Text	1
DateTime	1
Numeric	13
Categorical	1

Alerts

`AQI` is highly overall correlated with `AQI_Bucket` and 7 other fields	High correlation
`AQI_Bucket` is highly overall correlated with `AQI` and 1 other fields	High correlation
`Benzene` is highly overall correlated with `Toluene` and 1 other fields	High correlation
`CO` is highly overall correlated with `AQI` and 1 other fields	High correlation
`NH3` is highly overall correlated with `AQI` and 2 other fields	High correlation
`NO` is highly overall correlated with `AQI` and 4 other fields	High correlation
`NO2` is highly overall correlated with `AQI` and 4 other fields	High correlation
`NOx` is highly overall correlated with `AQI` and 3 other fields	High correlation
`PM10` is highly overall correlated with `AQI` and 7 other fields	High correlation
`PM2.5` is highly overall correlated with `AQI` and 4 other fields	High correlation
`Toluene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly overall correlated with `Benzene` and 1 other fields	High correlation
`PM2.5` has 21625 (20.0%) missing values	Missing
`PM10` has 42706 (39.5%) missing values	Missing
`NO` has 17106 (15.8%) missing values	Missing
`NO2` has 16547 (15.3%) missing values	Missing
`NOx` has 15500 (14.3%) missing values	Missing
`NH3` has 48105 (44.5%) missing values	Missing
`CO` has 12998 (12.0%) missing values	Missing
`SO2` has 25204 (23.3%) missing values	Missing
`O3` has 25568 (23.7%) missing values	Missing
`Benzene` has 31455 (29.1%) missing values	Missing
`Toluene` has 38702 (35.8%) missing values	Missing
`Xylene` has 85137 (78.8%) missing values	Missing
`AQI` has 21010 (19.4%) missing values	Missing
`AQI_Bucket` has 21010 (19.4%) missing values	Missing
`Benzene` is highly skewed (γ1 = 21.61702016)	Skewed
`NOx` has 4776 (4.4%) zeros	Zeros
`CO` has 7280 (6.7%) zeros	Zeros
`Benzene` has 12602 (11.7%) zeros	Zeros
`Toluene` has 10455 (9.7%) zeros	Zeros
`Xylene` has 6083 (5.6%) zeros	Zeros

Reproduction

Analysis started	2024-11-14 23:59:11.685070
Analysis finished	2024-11-15 00:00:11.275939
Duration	59.59 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

StationId
Text

Distinct	110
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	6.4 MiB

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	540175
Distinct characters	29
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AP001
2nd row	AP001
3rd row	AP001
4th row	AP001
5th row	AP001

Value	Count	Frequency (%)
ka003	2009	1.9%
dl013	2009	1.9%
tn004	2009	1.9%
tn003	2009	1.9%
tn001	2009	1.9%
up012	2009	1.9%
up014	2009	1.9%
dl007	2009	1.9%
dl008	2009	1.9%
gj001	2009	1.9%
Other values (100)	87945	81.4%

Most occurring characters

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	540175	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	540175	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	540175	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Date
Date

Distinct	2009
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	844.1 KiB

Minimum	2015-01-01 00:00:00
Maximum	2020-07-01 00:00:00

Histogram with fixed size bins (bins=50)

PM2.5
Real number (ℝ)

High correlation Missing

Distinct	22395
Distinct (%)	25.9%
Missing	21625
Missing (%)	20.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.272571

Minimum	0.02
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.02
5-th percentile	13.02
Q1	31.88
median	55.95
Q3	99.92
95-th percentile	236.5655
Maximum	1000
Range	999.98
Interquartile range (IQR)	68.04

Descriptive statistics

Standard deviation	76.526403
Coefficient of variation (CV)	0.95333189
Kurtosis	10.624383
Mean	80.272571
Median Absolute Deviation (MAD)	29.07
Skewness	2.5639235
Sum	6936352.9
Variance	5856.2903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	27	< 0.1%
31.08	23	< 0.1%
24.83	22	< 0.1%
28.8	22	< 0.1%
21.38	21	< 0.1%
29.75	21	< 0.1%
34.1	21	< 0.1%
42.5	21	< 0.1%
34	20	< 0.1%
21	20	< 0.1%
Other values (22385)	86192	79.8%
(Missing)	21625	20.0%

Value	Count	Frequency (%)
0.02	2	< 0.1%
0.04	1	< 0.1%
0.15	1	< 0.1%
0.16	1	< 0.1%
0.19	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.28	1	< 0.1%
0.32	1	< 0.1%

Value	Count	Frequency (%)
1000	1	< 0.1%
999.99	1	< 0.1%
995	1	< 0.1%
992.67	1	< 0.1%
949.99	1	< 0.1%
917.77	1	< 0.1%
916.67	1	< 0.1%
914.94	1	< 0.1%
914.64	1	< 0.1%
894.75	1	< 0.1%

PM10
Real number (ℝ)

High correlation Missing

Distinct	29575
Distinct (%)	45.3%
Missing	42706
Missing (%)	39.5%
Infinite	0
Infinite (%)	0.0%
Mean	157.96843

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	30.27
Q1	70.15
median	122.09
Q3	208.67
95-th percentile	409.386
Maximum	1000
Range	999.99
Interquartile range (IQR)	138.52

Descriptive statistics

Standard deviation	123.41867
Coefficient of variation (CV)	0.78128696
Kurtosis	3.3830811
Mean	157.96843
Median Absolute Deviation (MAD)	61.83
Skewness	1.6440481
Sum	10319919
Variance	15232.169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	12	< 0.1%
71.05	12	< 0.1%
71.88	12	< 0.1%
55.66	11	< 0.1%
108.46	11	< 0.1%
56.6	11	< 0.1%
49.46	10	< 0.1%
65.88	10	< 0.1%
41.62	10	< 0.1%
108.77	10	< 0.1%
Other values (29565)	65220	60.4%
(Missing)	42706	39.5%

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	2	< 0.1%
0.1	3	< 0.1%
0.12	3	< 0.1%

Value	Count	Frequency (%)
1000	1	< 0.1%
985	2	< 0.1%
976.77	1	< 0.1%
960.98	1	< 0.1%
955.6	1	< 0.1%
952	1	< 0.1%
942	1	< 0.1%
938.5	1	< 0.1%
936.25	1	< 0.1%
933.05	1	< 0.1%

NO
Real number (ℝ)

High correlation Missing

Distinct	11963
Distinct (%)	13.2%
Missing	17106
Missing (%)	15.8%
Infinite	0
Infinite (%)	0.0%
Mean	23.123424

Minimum	0.01
Maximum	470
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	1.5
Q1	4.84
median	10.29
Q3	24.98
95-th percentile	93.766
Maximum	470
Range	469.99
Interquartile range (IQR)	20.14

Descriptive statistics

Standard deviation	34.491019
Coefficient of variation (CV)	1.4916052
Kurtosis	14.052937
Mean	23.123424
Median Absolute Deviation (MAD)	7.02
Skewness	3.288711
Sum	2102589.8
Variance	1189.6304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.5	81	0.1%
2.89	79	0.1%
2.93	79	0.1%
2.49	77	0.1%
0.73	77	0.1%
2.87	76	0.1%
3	76	0.1%
2.95	75	0.1%
2.84	75	0.1%
3.99	75	0.1%
Other values (11953)	90159	83.5%
(Missing)	17106	15.8%

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.02	10	< 0.1%
0.03	4	< 0.1%
0.04	2	< 0.1%
0.06	3	< 0.1%
0.07	1	< 0.1%
0.08	3	< 0.1%
0.09	2	< 0.1%
0.1	4	< 0.1%
0.11	4	< 0.1%

Value	Count	Frequency (%)
470	1	< 0.1%
437.85	1	< 0.1%
436.8	1	< 0.1%
429.77	1	< 0.1%
403.94	1	< 0.1%
390.68	1	< 0.1%
383.14	1	< 0.1%
382.44	1	< 0.1%
374.71	1	< 0.1%
373.9	1	< 0.1%

NO2
Real number (ℝ)

High correlation Missing

Distinct	12050
Distinct (%)	13.2%
Missing	16547
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%
Mean	35.24076

Minimum	0.01
Maximum	448.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	5.3935
Q1	15.09
median	27.21
Q3	46.93
95-th percentile	89.88
Maximum	448.05
Range	448.04
Interquartile range (IQR)	31.84

Descriptive statistics

Standard deviation	29.510827
Coefficient of variation (CV)	0.83740609
Kurtosis	11.060617
Mean	35.24076
Median Absolute Deviation (MAD)	14.41
Skewness	2.3592871
Sum	3224106.7
Variance	870.88892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	43	< 0.1%
17.58	39	< 0.1%
20	37	< 0.1%
16.07	37	< 0.1%
9.47	36	< 0.1%
0.2	36	< 0.1%
17.82	36	< 0.1%
9.14	36	< 0.1%
9.22	35	< 0.1%
13.6	35	< 0.1%
Other values (12040)	91118	84.3%
(Missing)	16547	15.3%

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	7	< 0.1%
0.03	9	< 0.1%
0.04	3	< 0.1%
0.05	3	< 0.1%
0.06	3	< 0.1%
0.07	7	< 0.1%
0.08	6	< 0.1%
0.09	7	< 0.1%
0.1	8	< 0.1%

Value	Count	Frequency (%)
448.05	1	< 0.1%
397.77	1	< 0.1%
397.31	1	< 0.1%
394.04	1	< 0.1%
393.08	1	< 0.1%
369.03	1	< 0.1%
363.75	1	< 0.1%
362.73	1	< 0.1%
362.5	1	< 0.1%
362.21	1	< 0.1%

NOx
Real number (ℝ)

High correlation Missing Zeros

Distinct	15608
Distinct (%)	16.9%
Missing	15500
Missing (%)	14.3%
Infinite	0
Infinite (%)	0.0%
Mean	41.195055

Minimum	0
Maximum	467.63
Zeros	4776
Zeros (%)	4.4%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	13.97
median	26.66
Q3	50.5
95-th percentile	134.153
Maximum	467.63
Range	467.63
Interquartile range (IQR)	36.53

Descriptive statistics

Standard deviation	45.145976
Coefficient of variation (CV)	1.0959076
Kurtosis	8.4549145
Mean	41.195055
Median Absolute Deviation (MAD)	15.84
Skewness	2.5397855
Sum	3811984.5
Variance	2038.1591
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4776	4.4%
6.24	601	0.6%
2.21	516	0.5%
9.05	37	< 0.1%
16.56	34	< 0.1%
11.02	34	< 0.1%
17.01	34	< 0.1%
15.75	34	< 0.1%
22.02	34	< 0.1%
15.09	33	< 0.1%
Other values (15598)	86402	80.0%
(Missing)	15500	14.3%

Value	Count	Frequency (%)
0	4776	4.4%
0.01	7	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	13	< 0.1%
0.05	4	< 0.1%
0.06	2	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	2	< 0.1%

Value	Count	Frequency (%)
467.63	1	< 0.1%
453.61	1	< 0.1%
442.69	1	< 0.1%
440.31	1	< 0.1%
434.9	1	< 0.1%
429.38	1	< 0.1%
402.27	1	< 0.1%
399.87	1	< 0.1%
395.86	1	< 0.1%
395.33	1	< 0.1%

NH3
Real number (ℝ)

High correlation Missing

Distinct	9119
Distinct (%)	15.2%
Missing	48105
Missing (%)	44.5%
Infinite	0
Infinite (%)	0.0%
Mean	28.732875

Minimum	0.01
Maximum	418.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	3.85
Q1	11.9
median	23.59
Q3	38.1375
95-th percentile	70.23
Maximum	418.9
Range	418.89
Interquartile range (IQR)	26.2375

Descriptive statistics

Standard deviation	24.897797
Coefficient of variation (CV)	0.86652648
Kurtosis	22.771798
Mean	28.732875
Median Absolute Deviation (MAD)	12.6
Skewness	3.2189192
Sum	1721961.2
Variance	619.90031
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.42	49	< 0.1%
6.29	42	< 0.1%
14.62	39	< 0.1%
6.28	38	< 0.1%
6.3	38	< 0.1%
6.31	36	< 0.1%
6.6	34	< 0.1%
10.42	33	< 0.1%
6.32	32	< 0.1%
6.25	32	< 0.1%
Other values (9109)	59557	55.1%
(Missing)	48105	44.5%

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	9	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.05	2	< 0.1%
0.06	6	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	23	< 0.1%

Value	Count	Frequency (%)
418.9	1	< 0.1%
408.58	1	< 0.1%
379.32	1	< 0.1%
371.36	1	< 0.1%
365.68	1	< 0.1%
361.75	1	< 0.1%
356.73	1	< 0.1%
352.89	1	< 0.1%
349.25	1	< 0.1%
335.91	1	< 0.1%

CO
Real number (ℝ)

High correlation Missing Zeros

Distinct	2352
Distinct (%)	2.5%
Missing	12998
Missing (%)	12.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.6057493

Minimum	0
Maximum	175.81
Zeros	7280
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.53
median	0.91
Q3	1.45
95-th percentile	3.38
Maximum	175.81
Range	175.81
Interquartile range (IQR)	0.92

Descriptive statistics

Standard deviation	4.3695778
Coefficient of variation (CV)	2.7212079
Kurtosis	224.16889
Mean	1.6057493
Median Absolute Deviation (MAD)	0.43
Skewness	12.197951
Sum	152605.6
Variance	19.09321
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7280	6.7%
0.64	713	0.7%
0.66	696	0.6%
0.7	688	0.6%
0.78	679	0.6%
0.74	673	0.6%
0.68	671	0.6%
0.6	662	0.6%
0.79	659	0.6%
0.76	656	0.6%
Other values (2342)	81660	75.6%
(Missing)	12998	12.0%

Value	Count	Frequency (%)
0	7280	6.7%
0.01	96	0.1%
0.02	125	0.1%
0.03	54	< 0.1%
0.04	52	< 0.1%
0.05	73	0.1%
0.06	54	< 0.1%
0.07	45	< 0.1%
0.08	54	< 0.1%
0.09	59	0.1%

Value	Count	Frequency (%)
175.81	1	< 0.1%
145.32	1	< 0.1%
134.85	1	< 0.1%
132.47	1	< 0.1%
132.07	1	< 0.1%
124.01	1	< 0.1%
119.68	1	< 0.1%
119.3	1	< 0.1%
118.02	1	< 0.1%
118	1	< 0.1%

SO2
Real number (ℝ)

Missing

Distinct	5801
Distinct (%)	7.0%
Missing	25204
Missing (%)	23.3%
Infinite	0
Infinite (%)	0.0%
Mean	12.257634

Minimum	0.01
Maximum	195.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	2.07
Q1	5.04
median	8.95
Q3	14.92
95-th percentile	32.54
Maximum	195.65
Range	195.64
Interquartile range (IQR)	9.88

Descriptive statistics

Standard deviation	12.984723
Coefficient of variation (CV)	1.0593173
Kurtosis	34.720632
Mean	12.257634
Median Absolute Deviation (MAD)	4.54
Skewness	4.5812814
Sum	1015312.1
Variance	168.60304
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.4	84	0.1%
3.38	80	0.1%
4	79	0.1%
5.86	78	0.1%
3.28	75	0.1%
3.48	75	0.1%
3.51	75	0.1%
6.42	74	0.1%
4.76	74	0.1%
6.99	74	0.1%
Other values (5791)	82063	76.0%
(Missing)	25204	23.3%

Value	Count	Frequency (%)
0.01	2	< 0.1%
0.02	1	< 0.1%
0.03	3	< 0.1%
0.04	6	< 0.1%
0.05	3	< 0.1%
0.06	8	< 0.1%
0.07	3	< 0.1%
0.08	10	< 0.1%
0.09	4	< 0.1%
0.1	6	< 0.1%

Value	Count	Frequency (%)
195.65	1	< 0.1%
193.86	1	< 0.1%
187.02	1	< 0.1%
186.08	1	< 0.1%
182.39	1	< 0.1%
180.85	1	< 0.1%
179.18	1	< 0.1%
178.93	1	< 0.1%
178.63	1	< 0.1%
178.58	1	< 0.1%

O3
Real number (ℝ)

Missing

Distinct	11166
Distinct (%)	13.5%
Missing	25568
Missing (%)	23.7%
Infinite	0
Infinite (%)	0.0%
Mean	38.134836

Minimum	0.01
Maximum	963
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0.01
5-th percentile	7.02
Q1	18.895
median	30.84
Q3	47.14
95-th percentile	81
Maximum	963
Range	962.99
Interquartile range (IQR)	28.245

Descriptive statistics

Standard deviation	39.128004
Coefficient of variation (CV)	1.0260436
Kurtosis	75.831363
Mean	38.134836
Median Absolute Deviation (MAD)	13.49
Skewness	6.8444834
Sum	3144865.5
Variance	1531.0007
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.48	35	< 0.1%
22.94	34	< 0.1%
23.6	33	< 0.1%
22.5	33	< 0.1%
34.4	32	< 0.1%
19.12	31	< 0.1%
25.64	31	< 0.1%
23.59	31	< 0.1%
21.4	30	< 0.1%
21.28	29	< 0.1%
Other values (11156)	82148	76.0%
(Missing)	25568	23.7%

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	9	< 0.1%
0.03	4	< 0.1%
0.04	3	< 0.1%
0.05	4	< 0.1%
0.06	3	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	3	< 0.1%
0.1	11	< 0.1%

Value	Count	Frequency (%)
963	1	< 0.1%
868.2	1	< 0.1%
819.06	1	< 0.1%
777.67	1	< 0.1%
763.12	1	< 0.1%
757	1	< 0.1%
714.75	1	< 0.1%
705.32	1	< 0.1%
698.67	1	< 0.1%
694.96	1	< 0.1%

Benzene
Real number (ℝ)

High correlation Missing Skewed Zeros

Distinct	3017
Distinct (%)	3.9%
Missing	31455
Missing (%)	29.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.3580293

Minimum	0
Maximum	455.03
Zeros	12602
Zeros (%)	11.7%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.16
median	1.21
Q3	3.61
95-th percentile	11.35
Maximum	455.03
Range	455.03
Interquartile range (IQR)	3.45

Descriptive statistics

Standard deviation	11.156234
Coefficient of variation (CV)	3.3222565
Kurtosis	695.20283
Mean	3.3580293
Median Absolute Deviation (MAD)	1.21
Skewness	21.61702
Sum	257157.88
Variance	124.46157
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12602	11.7%
0.1	689	0.6%
0.01	541	0.5%
0.02	474	0.4%
0.12	439	0.4%
0.11	422	0.4%
0.03	420	0.4%
0.05	409	0.4%
0.04	403	0.4%
0.13	398	0.4%
Other values (3007)	59783	55.3%
(Missing)	31455	29.1%

Value	Count	Frequency (%)
0	12602	11.7%
0.01	541	0.5%
0.02	474	0.4%
0.03	420	0.4%
0.04	403	0.4%
0.05	409	0.4%
0.06	374	0.3%
0.07	321	0.3%
0.08	337	0.3%
0.09	337	0.3%

Value	Count	Frequency (%)
455.03	1	< 0.1%
454.85	1	< 0.1%
449.38	1	< 0.1%
448.59	1	< 0.1%
445.83	1	< 0.1%
443.63	1	< 0.1%
438.01	1	< 0.1%
435.9	1	< 0.1%
435.09	1	< 0.1%
432.94	1	< 0.1%

Toluene
Real number (ℝ)

High correlation Missing Zeros

Distinct	8713
Distinct (%)	12.6%
Missing	38702
Missing (%)	35.8%
Infinite	0
Infinite (%)	0.0%
Mean	15.345394

Minimum	0
Maximum	454.85
Zeros	10455
Zeros (%)	9.7%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.69
median	4.33
Q3	17.51
95-th percentile	64.934
Maximum	454.85
Range	454.85
Interquartile range (IQR)	16.82

Descriptive statistics

Standard deviation	29.348587
Coefficient of variation (CV)	1.9125339
Kurtosis	33.337213
Mean	15.345394
Median Absolute Deviation (MAD)	4.33
Skewness	4.5983348
Sum	1063942.2
Variance	861.33958
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10455	9.7%
0.01	268	0.2%
0.02	199	0.2%
0.07	198	0.2%
0.03	179	0.2%
0.04	173	0.2%
0.1	173	0.2%
0.08	167	0.2%
0.06	161	0.1%
0.09	153	0.1%
Other values (8703)	57207	53.0%
(Missing)	38702	35.8%

Value	Count	Frequency (%)
0	10455	9.7%
0.01	268	0.2%
0.02	199	0.2%
0.03	179	0.2%
0.04	173	0.2%
0.05	147	0.1%
0.06	161	0.1%
0.07	198	0.2%
0.08	167	0.2%
0.09	153	0.1%

Value	Count	Frequency (%)
454.85	1	< 0.1%
454.12	1	< 0.1%
449.14	1	< 0.1%
448.87	1	< 0.1%
445.84	1	< 0.1%
443.63	1	< 0.1%
437.77	1	< 0.1%
435.94	1	< 0.1%
434.92	1	< 0.1%
433.02	1	< 0.1%

Xylene
Real number (ℝ)

High correlation Missing Zeros

Distinct	1892
Distinct (%)	8.3%
Missing	85137
Missing (%)	78.8%
Infinite	0
Infinite (%)	0.0%
Mean	2.4234462

Minimum	0
Maximum	170.37
Zeros	6083
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.4
Q3	2.11
95-th percentile	10.7315
Maximum	170.37
Range	170.37
Interquartile range (IQR)	2.11

Descriptive statistics

Standard deviation	6.4724085
Coefficient of variation (CV)	2.6707457
Kurtosis	119.56916
Mean	2.4234462
Median Absolute Deviation (MAD)	0.4
Skewness	8.629739
Sum	55492.07
Variance	41.892072
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6083	5.6%
0.01	500	0.5%
0.02	423	0.4%
0.1	327	0.3%
0.03	297	0.3%
0.04	241	0.2%
0.05	188	0.2%
0.12	183	0.2%
0.06	180	0.2%
0.11	168	0.2%
Other values (1882)	14308	13.2%
(Missing)	85137	78.8%

Value	Count	Frequency (%)
0	6083	5.6%
0.01	500	0.5%
0.02	423	0.4%
0.03	297	0.3%
0.04	241	0.2%
0.05	188	0.2%
0.06	180	0.2%
0.07	151	0.1%
0.08	148	0.1%
0.09	135	0.1%

Value	Count	Frequency (%)
170.37	1	< 0.1%
137.45	1	< 0.1%
133.6	1	< 0.1%
132.97	1	< 0.1%
129.28	1	< 0.1%
125.18	1	< 0.1%
123.29	1	< 0.1%
116.62	1	< 0.1%
109.98	1	< 0.1%
109.23	1	< 0.1%

AQI
Real number (ℝ)

High correlation Missing

Distinct	930
Distinct (%)	1.1%
Missing	21010
Missing (%)	19.4%
Infinite	0
Infinite (%)	0.0%
Mean	179.74929

Minimum	8
Maximum	2049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	844.1 KiB

Quantile statistics

Minimum	8
5-th percentile	47
Q1	86
median	132
Q3	254
95-th percentile	415
Maximum	2049
Range	2041
Interquartile range (IQR)	168

Descriptive statistics

Standard deviation	131.32434
Coefficient of variation (CV)	0.73059726
Kurtosis	8.5325443
Mean	179.74929
Median Absolute Deviation (MAD)	62
Skewness	1.9300877
Sum	15642682
Variance	17246.082
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
104	615	0.6%
102	593	0.5%
106	587	0.5%
108	561	0.5%
100	560	0.5%
88	549	0.5%
98	547	0.5%
92	546	0.5%
90	546	0.5%
78	545	0.5%
Other values (920)	81376	75.3%
(Missing)	21010	19.4%

Value	Count	Frequency (%)
8	1	< 0.1%
10	2	< 0.1%
13	2	< 0.1%
14	7	< 0.1%
15	5	< 0.1%
16	10	< 0.1%
17	13	< 0.1%
18	11	< 0.1%
19	36	< 0.1%
20	49	< 0.1%

Value	Count	Frequency (%)
2049	1	< 0.1%
1917	1	< 0.1%
1842	1	< 0.1%
1747	1	< 0.1%
1719	1	< 0.1%
1672	1	< 0.1%
1646	1	< 0.1%
1630	1	< 0.1%
1613	1	< 0.1%
1595	1	< 0.1%

AQI_Bucket
Categorical

High correlation Missing

Distinct	6
Distinct (%)	< 0.1%
Missing	21010
Missing (%)	19.4%
Memory size	6.2 MiB

Moderate	29417
Satisfactory	23636
Very Poor	11762
Poor	11493
Good	5510

Length

Max length	12
Median length	9
Mean length	8.3203677
Min length	4

Characters and Unicode

Total characters	724080
Distinct characters	18
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Moderate	29417	27.2%
Satisfactory	23636	21.9%
Very Poor	11762	10.9%
Poor	11493	10.6%
Good	5510	5.1%
Severe	5207	4.8%
(Missing)	21010	19.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
moderate	29417	29.8%
satisfactory	23636	23.9%
poor	23255	23.5%
very	11762	11.9%
good	5510	5.6%
severe	5207	5.3%

Most occurring characters

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	724080	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	724080	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	724080	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

	AQI	AQI_Bucket	Benzene	CO	NH3	NO	NO2	NOx	O3	PM10	PM2.5	SO2	Toluene	Xylene
AQI	1.000	0.584	0.358	0.553	0.523	0.520	0.518	0.526	0.205	0.896	0.880	0.406	0.362	0.143
AQI_Bucket	0.584	1.000	0.029	0.131	0.192	0.194	0.218	0.231	0.128	0.557	0.469	0.146	0.132	0.042
Benzene	0.358	0.029	1.000	0.339	0.291	0.344	0.425	0.400	0.089	0.364	0.348	0.275	0.831	0.838
CO	0.553	0.131	0.339	1.000	0.419	0.440	0.373	0.449	0.043	0.516	0.475	0.269	0.375	0.340
NH3	0.523	0.192	0.291	0.419	1.000	0.359	0.464	0.406	0.109	0.523	0.515	0.265	0.367	0.055
NO	0.520	0.194	0.344	0.440	0.359	1.000	0.575	0.805	-0.104	0.520	0.504	0.316	0.321	0.198
NO2	0.518	0.218	0.425	0.373	0.464	0.575	1.000	0.777	0.180	0.531	0.515	0.320	0.452	0.275
NOx	0.526	0.231	0.400	0.449	0.406	0.805	0.777	1.000	0.012	0.535	0.498	0.320	0.385	0.279
O3	0.205	0.128	0.089	0.043	0.109	-0.104	0.180	0.012	1.000	0.127	0.157	0.195	0.071	0.121
PM10	0.896	0.557	0.364	0.516	0.523	0.520	0.531	0.535	0.127	1.000	0.898	0.407	0.362	0.039
PM2.5	0.880	0.469	0.348	0.475	0.515	0.504	0.515	0.498	0.157	0.898	1.000	0.340	0.323	0.131
SO2	0.406	0.146	0.275	0.269	0.265	0.316	0.320	0.320	0.195	0.407	0.340	1.000	0.385	0.235
Toluene	0.362	0.132	0.831	0.375	0.367	0.321	0.452	0.385	0.071	0.362	0.323	0.385	1.000	0.770
Xylene	0.143	0.042	0.838	0.340	0.055	0.198	0.275	0.279	0.121	0.039	0.131	0.235	0.770	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	StationId	Date	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
0	AP001	2017-11-24	71.36	115.75	1.75	20.65	12.40	12.19	0.10	10.76	109.26	0.17	5.92	0.10	NaN	NaN
1	AP001	2017-11-25	81.40	124.50	1.44	20.50	12.08	10.72	0.12	15.24	127.09	0.20	6.50	0.06	184.0	Moderate
2	AP001	2017-11-26	78.32	129.06	1.26	26.00	14.85	10.28	0.14	26.96	117.44	0.22	7.95	0.08	197.0	Moderate
3	AP001	2017-11-27	88.76	135.32	6.60	30.85	21.77	12.91	0.11	33.59	111.81	0.29	7.63	0.12	198.0	Moderate
4	AP001	2017-11-28	64.18	104.09	2.56	28.07	17.01	11.42	0.09	19.00	138.18	0.17	5.02	0.07	188.0	Moderate
5	AP001	2017-11-29	72.47	114.84	5.23	23.20	16.59	12.25	0.16	10.55	109.74	0.21	4.71	0.08	173.0	Moderate
6	AP001	2017-11-30	69.80	114.86	4.69	20.17	14.54	10.95	0.12	14.07	118.09	0.16	3.52	0.06	165.0	Moderate
7	AP001	2017-12-01	73.96	113.56	4.58	19.29	13.97	10.95	0.10	13.90	123.80	0.17	2.85	0.04	191.0	Moderate
8	AP001	2017-12-02	89.90	140.20	7.71	26.19	19.87	13.12	0.10	19.37	128.73	0.25	2.79	0.07	191.0	Moderate
9	AP001	2017-12-03	87.14	130.52	0.97	21.31	12.12	14.36	0.15	11.41	114.80	0.23	3.82	0.04	227.0	Poor

	StationId	Date	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket
108025	WB013	2020-06-22	15.10	30.98	2.59	18.04	20.63	30.34	0.67	1.50	25.84	1.28	8.32	NaN	38.0	Good
108026	WB013	2020-06-23	19.48	42.37	3.06	20.94	23.99	32.53	0.70	1.72	28.21	1.65	5.93	NaN	44.0	Good
108027	WB013	2020-06-24	20.05	46.63	3.78	15.28	19.06	18.89	0.66	7.08	41.56	1.14	7.24	NaN	59.0	Satisfactory
108028	WB013	2020-06-25	17.03	39.64	3.23	11.42	14.65	18.98	0.57	11.39	31.76	0.79	6.85	NaN	56.0	Satisfactory
108029	WB013	2020-06-26	9.79	19.87	23.51	16.50	40.02	25.09	0.66	10.34	30.19	0.93	6.37	NaN	50.0	Good
108030	WB013	2020-06-27	8.65	16.46	NaN	NaN	NaN	NaN	0.69	4.36	30.59	1.32	7.26	NaN	50.0	Good
108031	WB013	2020-06-28	11.80	18.47	NaN	NaN	NaN	NaN	0.68	3.49	38.95	1.42	7.92	NaN	65.0	Satisfactory
108032	WB013	2020-06-29	18.60	32.26	13.65	200.87	214.20	11.40	0.78	5.12	38.17	3.52	8.64	NaN	63.0	Satisfactory
108033	WB013	2020-06-30	16.07	39.30	7.56	29.13	36.69	29.26	0.69	5.88	29.64	1.86	8.40	NaN	57.0	Satisfactory
108034	WB013	2020-07-01	10.50	36.50	7.78	22.50	30.25	27.23	0.58	2.80	13.10	1.31	7.39	NaN	59.0	Satisfactory

Overview

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample